Dataset statistics
| Number of variables | 38 |
|---|---|
| Number of observations | 1620 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 411.5 KiB |
| Average record size in memory | 260.1 B |
Variable types
| Numeric | 24 |
|---|---|
| Categorical | 9 |
| DateTime | 5 |
msno has a high cardinality: 1620 distinct values | High cardinality |
bd is highly correlated with gender | High correlation |
gender is highly correlated with bd | High correlation |
total_payment_channels is highly correlated with total_transactions and 3 other fields | High correlation |
change_in_payment_methods is highly correlated with change_in_plan | High correlation |
payment_plan_days_mean is highly correlated with plan_list_price_mean and 1 other fields | High correlation |
change_in_plan is highly correlated with change_in_payment_methods | High correlation |
plan_list_price_mean is highly correlated with payment_plan_days_mean and 1 other fields | High correlation |
actual_amount_paid_mean is highly correlated with payment_plan_days_mean and 1 other fields | High correlation |
is_auto_renew_mean is highly correlated with is_autorenew_change_flag | High correlation |
is_autorenew_change_flag is highly correlated with is_auto_renew_mean | High correlation |
total_transactions is highly correlated with total_payment_channels and 3 other fields | High correlation |
is_cancel_mean is highly correlated with is_cancel_change_flag | High correlation |
is_cancel_change_flag is highly correlated with is_cancel_mean | High correlation |
discount_mean is highly correlated with is_discount_mean and 1 other fields | High correlation |
is_discount_mean is highly correlated with discount_mean and 1 other fields | High correlation |
is_discount_max is highly correlated with discount_mean and 1 other fields | High correlation |
more_than_30_sum is highly correlated with total_payment_channels and 2 other fields | High correlation |
num_25 is highly correlated with num_50 and 3 other fields | High correlation |
num_50 is highly correlated with num_25 and 2 other fields | High correlation |
num_75 is highly correlated with num_25 and 2 other fields | High correlation |
num_985 is highly correlated with num_25 and 2 other fields | High correlation |
num_100 is highly correlated with num_unq and 1 other fields | High correlation |
num_unq is highly correlated with num_25 and 2 other fields | High correlation |
total_secs is highly correlated with num_100 and 1 other fields | High correlation |
login_freq is highly correlated with total_payment_channels and 2 other fields | High correlation |
registration_duration is highly correlated with total_payment_channels and 3 other fields | High correlation |
bd is highly correlated with gender | High correlation |
gender is highly correlated with bd | High correlation |
total_payment_channels is highly correlated with total_transactions and 3 other fields | High correlation |
change_in_payment_methods is highly correlated with change_in_plan and 1 other fields | High correlation |
change_in_plan is highly correlated with change_in_payment_methods | High correlation |
plan_list_price_mean is highly correlated with actual_amount_paid_mean and 2 other fields | High correlation |
actual_amount_paid_mean is highly correlated with plan_list_price_mean and 2 other fields | High correlation |
is_auto_renew_mean is highly correlated with change_in_payment_methods and 3 other fields | High correlation |
is_autorenew_change_flag is highly correlated with is_auto_renew_mean | High correlation |
total_transactions is highly correlated with total_payment_channels and 3 other fields | High correlation |
is_cancel_mean is highly correlated with is_cancel_change_flag | High correlation |
is_cancel_change_flag is highly correlated with is_cancel_mean | High correlation |
discount_mean is highly correlated with is_discount_mean and 1 other fields | High correlation |
is_discount_mean is highly correlated with discount_mean and 1 other fields | High correlation |
is_discount_max is highly correlated with discount_mean and 1 other fields | High correlation |
amt_per_day_mean is highly correlated with plan_list_price_mean and 1 other fields | High correlation |
more_than_30_sum is highly correlated with total_payment_channels and 2 other fields | High correlation |
num_25 is highly correlated with num_50 and 2 other fields | High correlation |
num_50 is highly correlated with num_25 and 2 other fields | High correlation |
num_75 is highly correlated with num_25 and 2 other fields | High correlation |
num_985 is highly correlated with num_25 and 2 other fields | High correlation |
num_100 is highly correlated with num_unq and 1 other fields | High correlation |
num_unq is highly correlated with num_100 and 1 other fields | High correlation |
total_secs is highly correlated with num_100 and 1 other fields | High correlation |
login_freq is highly correlated with total_payment_channels and 2 other fields | High correlation |
registration_duration is highly correlated with total_payment_channels and 3 other fields | High correlation |
bd is highly correlated with gender | High correlation |
gender is highly correlated with bd | High correlation |
total_payment_channels is highly correlated with total_transactions and 2 other fields | High correlation |
change_in_payment_methods is highly correlated with change_in_plan and 1 other fields | High correlation |
change_in_plan is highly correlated with change_in_payment_methods | High correlation |
plan_list_price_mean is highly correlated with actual_amount_paid_mean and 1 other fields | High correlation |
actual_amount_paid_mean is highly correlated with plan_list_price_mean and 1 other fields | High correlation |
is_auto_renew_mean is highly correlated with change_in_payment_methods and 1 other fields | High correlation |
is_autorenew_change_flag is highly correlated with is_auto_renew_mean | High correlation |
total_transactions is highly correlated with total_payment_channels and 2 other fields | High correlation |
is_cancel_mean is highly correlated with is_cancel_change_flag | High correlation |
is_cancel_change_flag is highly correlated with is_cancel_mean | High correlation |
discount_mean is highly correlated with is_discount_mean and 1 other fields | High correlation |
is_discount_mean is highly correlated with discount_mean and 1 other fields | High correlation |
is_discount_max is highly correlated with discount_mean and 1 other fields | High correlation |
amt_per_day_mean is highly correlated with plan_list_price_mean and 1 other fields | High correlation |
more_than_30_sum is highly correlated with total_payment_channels and 2 other fields | High correlation |
num_25 is highly correlated with num_50 | High correlation |
num_50 is highly correlated with num_25 and 1 other fields | High correlation |
num_75 is highly correlated with num_50 and 1 other fields | High correlation |
num_985 is highly correlated with num_75 | High correlation |
num_100 is highly correlated with num_unq and 1 other fields | High correlation |
num_unq is highly correlated with num_100 and 1 other fields | High correlation |
total_secs is highly correlated with num_100 and 1 other fields | High correlation |
registration_duration is highly correlated with total_payment_channels and 2 other fields | High correlation |
change_in_plan is highly correlated with amt_per_day_mean and 8 other fields | High correlation |
amt_per_day_mean is highly correlated with change_in_plan and 11 other fields | High correlation |
city is highly correlated with bd and 3 other fields | High correlation |
total_transactions is highly correlated with change_in_plan and 4 other fields | High correlation |
is_autorenew_change_flag is highly correlated with amt_per_day_mean and 5 other fields | High correlation |
is_churn is highly correlated with is_autorenew_change_flag and 2 other fields | High correlation |
bd is highly correlated with city and 2 other fields | High correlation |
is_auto_renew_mean is highly correlated with amt_per_day_mean and 4 other fields | High correlation |
payment_plan_days_mean is highly correlated with amt_per_day_mean and 4 other fields | High correlation |
change_in_payment_methods is highly correlated with change_in_plan and 2 other fields | High correlation |
total_payment_channels is highly correlated with change_in_plan and 4 other fields | High correlation |
num_985 is highly correlated with num_50 and 1 other fields | High correlation |
is_cancel_change_flag is highly correlated with is_cancel_mean and 1 other fields | High correlation |
is_cancel_mean is highly correlated with is_cancel_change_flag and 1 other fields | High correlation |
num_50 is highly correlated with num_985 and 3 other fields | High correlation |
num_75 is highly correlated with num_985 and 2 other fields | High correlation |
is_discount_max is highly correlated with amt_per_day_mean and 3 other fields | High correlation |
transaction_date_max is highly correlated with change_in_plan and 10 other fields | High correlation |
membership_expire_date_max is highly correlated with amt_per_day_mean and 8 other fields | High correlation |
login_freq is highly correlated with total_transactions and 3 other fields | High correlation |
gender is highly correlated with city and 1 other fields | High correlation |
plan_list_price_mean is highly correlated with amt_per_day_mean and 4 other fields | High correlation |
registration_duration is highly correlated with change_in_plan and 5 other fields | High correlation |
is_discount_mean is highly correlated with is_discount_max and 1 other fields | High correlation |
num_25 is highly correlated with num_50 and 2 other fields | High correlation |
total_secs is highly correlated with num_unq and 1 other fields | High correlation |
more_than_30_sum is highly correlated with change_in_plan and 8 other fields | High correlation |
actual_amount_paid_mean is highly correlated with amt_per_day_mean and 4 other fields | High correlation |
num_unq is highly correlated with num_50 and 3 other fields | High correlation |
discount_mean is highly correlated with change_in_plan and 3 other fields | High correlation |
registered_via is highly correlated with change_in_plan and 8 other fields | High correlation |
num_100 is highly correlated with total_secs and 1 other fields | High correlation |
is_autorenew_change_flag is highly correlated with registered_via | High correlation |
registered_via is highly correlated with is_autorenew_change_flag | High correlation |
membership_duration_mean is highly skewed (γ1 = -37.92216912) | Skewed |
msno is uniformly distributed | Uniform |
df_index has unique values | Unique |
msno has unique values | Unique |
is_auto_renew_mean has 237 (14.6%) zeros | Zeros |
is_cancel_mean has 1395 (86.1%) zeros | Zeros |
discount_mean has 1438 (88.8%) zeros | Zeros |
is_discount_mean has 1520 (93.8%) zeros | Zeros |
more_than_30_sum has 210 (13.0%) zeros | Zeros |
num_25 has 70 (4.3%) zeros | Zeros |
num_50 has 265 (16.4%) zeros | Zeros |
num_75 has 410 (25.3%) zeros | Zeros |
num_985 has 405 (25.0%) zeros | Zeros |
num_100 has 22 (1.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-19 11:03:22.350799 |
|---|---|
| Analysis finished | 2023-05-19 11:04:39.829980 |
| Duration | 1 minute and 17.48 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 1620 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 164011.6519 |
| Minimum | 46 |
|---|---|
| Maximum | 323899 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 46 |
|---|---|
| 5-th percentile | 18563.4 |
| Q1 | 84342 |
| median | 162677.5 |
| Q3 | 245104.25 |
| 95-th percentile | 308231.75 |
| Maximum | 323899 |
| Range | 323853 |
| Interquartile range (IQR) | 160762.25 |
Descriptive statistics
| Standard deviation | 93348.64663 |
|---|---|
| Coefficient of variation (CV) | 0.5691586273 |
| Kurtosis | -1.201181249 |
| Mean | 164011.6519 |
| Median Absolute Deviation (MAD) | 80650.5 |
| Skewness | -0.00572715963 |
| Sum | 265698876 |
| Variance | 8713969827 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 97370 | 1 | 0.1% |
| 259561 | 1 | 0.1% |
| 263695 | 1 | 0.1% |
| 18565 | 1 | 0.1% |
| 259679 | 1 | 0.1% |
| 226247 | 1 | 0.1% |
| 283381 | 1 | 0.1% |
| 259642 | 1 | 0.1% |
| 231922 | 1 | 0.1% |
| 152819 | 1 | 0.1% |
| Other values (1610) | 1610 |
| Value | Count | Frequency (%) |
| 46 | 1 | |
| 398 | 1 | |
| 598 | 1 | |
| 674 | 1 | |
| 734 | 1 | |
| 954 | 1 | |
| 1319 | 1 | |
| 1429 | 1 | |
| 1469 | 1 | |
| 2066 | 1 |
| Value | Count | Frequency (%) |
| 323899 | 1 | |
| 323744 | 1 | |
| 323650 | 1 | |
| 323456 | 1 | |
| 323362 | 1 | |
| 323344 | 1 | |
| 323169 | 1 | |
| 322821 | 1 | |
| 322465 | 1 | |
| 322156 | 1 |
| Distinct | 1620 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| w8s1oZwdZVugLhPzRsSmfFBeniLGowuLi7NgY9FCq44= | 1 |
|---|---|
| 4iUeTCbgS85/LHCudzqRUY9K7uZUaV+XmTLjIYUF23I= | 1 |
| 2+xPFcvkGfuCT8qR0zgaokU5UZCNYMgNb81CNU/P9Go= | 1 |
| JpWaI65ySCqcBU8OPLZzhthGVmXDl0ELqJmy7U92MHg= | 1 |
| sJwXclAfmrjPjVl/cqyVKVP7kjERclaUtbs/dhr2Obs= | 1 |
| Other values (1615) |
Length
| Max length | 44 |
|---|---|
| Median length | 44 |
| Mean length | 44 |
| Min length | 44 |
Characters and Unicode
| Total characters | 71280 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1620 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | w8s1oZwdZVugLhPzRsSmfFBeniLGowuLi7NgY9FCq44= |
|---|---|
| 2nd row | cnncNsMOZE3kiTKQNSBbVCJMdE+PKr56pBYYeHWJ8Zk= |
| 3rd row | aWZDoNfiZtG0IWeC0++ocJXLZORBwDvkYA2rCBA4yAs= |
| 4th row | Ph7IvMxuu+1hJp8qYOAy5llX7D97espKsmhEgicBKls= |
| 5th row | cdrXUooJ9G1gXiLFd5NWqQ5HpgmNzl0aeaojPBJ203k= |
Common Values
| Value | Count | Frequency (%) |
| w8s1oZwdZVugLhPzRsSmfFBeniLGowuLi7NgY9FCq44= | 1 | 0.1% |
| 4iUeTCbgS85/LHCudzqRUY9K7uZUaV+XmTLjIYUF23I= | 1 | 0.1% |
| 2+xPFcvkGfuCT8qR0zgaokU5UZCNYMgNb81CNU/P9Go= | 1 | 0.1% |
| JpWaI65ySCqcBU8OPLZzhthGVmXDl0ELqJmy7U92MHg= | 1 | 0.1% |
| sJwXclAfmrjPjVl/cqyVKVP7kjERclaUtbs/dhr2Obs= | 1 | 0.1% |
| DymODQGTZFEJXnF0hn2SuGTYNrSVGvqwFP+K1sGW6og= | 1 | 0.1% |
| Ws4XrZKX0bs08dB7pJfDGChW3wY4jf3UMbOmtxsy3/U= | 1 | 0.1% |
| LnieTLWsIZjnIVzWh0pY9hAmN1JmX7IZB+rbBsTk+y8= | 1 | 0.1% |
| U6+yJJmRLW0bcsNAQ4Iq5bK9kQppsAG55FF3Tvq0dXk= | 1 | 0.1% |
| 9P1MuH3mqyH3Sd6+lJVmqjQxIITaFwN4bWMkg+QYFFQ= | 1 | 0.1% |
| Other values (1610) | 1610 |
Length
| Value | Count | Frequency (%) |
| w8s1ozwdzvuglhpzrssmffbenilgowuli7ngy9fcq44 | 1 | 0.1% |
| 4iuetcbgs85/lhcudzqruy9k7uzuav+xmtljiyuf23i | 1 | 0.1% |
| 2+xpfcvkgfuct8qr0zgaoku5uzcnymgnb81cnu/p9go | 1 | 0.1% |
| jpwai65yscqcbu8oplzzhthgvmxdl0elqjmy7u92mhg | 1 | 0.1% |
| sjwxclafmrjpjvl/cqyvkvp7kjerclautbs/dhr2obs | 1 | 0.1% |
| dymodqgtzfejxnf0hn2sugtynrsvgvqwfp+k1sgw6og | 1 | 0.1% |
| ws4xrzkx0bs08db7pjfdgchw3wy4jf3umbomtxsy3/u | 1 | 0.1% |
| lnietlwsizjnivzwh0py9hamn1jmx7izb+rbbstk+y8 | 1 | 0.1% |
| u6+yjjmrlw0bcsnaq4iq5bk9kqppsag55ff3tvq0dxk | 1 | 0.1% |
| 9p1muh3mqyh3sd6+ljvmqjqxiitafwn4bwmkg+qyffq | 1 | 0.1% |
| Other values (1610) | 1610 |
Most occurring characters
| Value | Count | Frequency (%) |
| = | 1620 | 2.3% |
| 8 | 1216 | 1.7% |
| c | 1215 | 1.7% |
| o | 1197 | 1.7% |
| I | 1182 | 1.7% |
| M | 1181 | 1.7% |
| 0 | 1181 | 1.7% |
| s | 1164 | 1.6% |
| g | 1158 | 1.6% |
| A | 1158 | 1.6% |
| Other values (55) | 59008 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 28452 | |
| Uppercase Letter | 28227 | |
| Decimal Number | 10747 | 15.1% |
| Math Symbol | 2759 | 3.9% |
| Other Punctuation | 1095 | 1.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 1215 | 4.3% |
| o | 1197 | 4.2% |
| s | 1164 | 4.1% |
| g | 1158 | 4.1% |
| w | 1157 | 4.1% |
| k | 1155 | 4.1% |
| b | 1112 | 3.9% |
| j | 1110 | 3.9% |
| r | 1103 | 3.9% |
| i | 1101 | 3.9% |
| Other values (16) | 16980 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 1182 | 4.2% |
| M | 1181 | 4.2% |
| A | 1158 | 4.1% |
| Q | 1152 | 4.1% |
| E | 1145 | 4.1% |
| Y | 1139 | 4.0% |
| U | 1136 | 4.0% |
| L | 1132 | 4.0% |
| T | 1114 | 3.9% |
| R | 1111 | 3.9% |
| Other values (16) | 16777 |
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 1216 | |
| 0 | 1181 | |
| 4 | 1128 | |
| 9 | 1059 | |
| 3 | 1052 | |
| 1 | 1036 | |
| 7 | 1032 | |
| 6 | 1029 | |
| 2 | 1011 | |
| 5 | 1003 |
Math Symbol
| Value | Count | Frequency (%) |
| = | 1620 | |
| + | 1139 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1095 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 56679 | |
| Common | 14601 | 20.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 1215 | 2.1% |
| o | 1197 | 2.1% |
| I | 1182 | 2.1% |
| M | 1181 | 2.1% |
| s | 1164 | 2.1% |
| g | 1158 | 2.0% |
| A | 1158 | 2.0% |
| w | 1157 | 2.0% |
| k | 1155 | 2.0% |
| Q | 1152 | 2.0% |
| Other values (42) | 44960 |
Common
| Value | Count | Frequency (%) |
| = | 1620 | |
| 8 | 1216 | 8.3% |
| 0 | 1181 | 8.1% |
| + | 1139 | 7.8% |
| 4 | 1128 | 7.7% |
| / | 1095 | 7.5% |
| 9 | 1059 | 7.3% |
| 3 | 1052 | 7.2% |
| 1 | 1036 | 7.1% |
| 7 | 1032 | 7.1% |
| Other values (3) | 3043 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 71280 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| = | 1620 | 2.3% |
| 8 | 1216 | 1.7% |
| c | 1215 | 1.7% |
| o | 1197 | 1.7% |
| I | 1182 | 1.7% |
| M | 1181 | 1.7% |
| 0 | 1181 | 1.7% |
| s | 1164 | 1.6% |
| g | 1158 | 1.6% |
| A | 1158 | 1.6% |
| Other values (55) | 59008 |
| Distinct | 20 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.359876543 |
| Minimum | 1 |
|---|---|
| Maximum | 22 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 5 |
| 95-th percentile | 18 |
| Maximum | 22 |
| Range | 21 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 5.857120697 |
|---|---|
| Coefficient of variation (CV) | 1.343414347 |
| Kurtosis | 1.761705001 |
| Mean | 4.359876543 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.70404063 |
| Sum | 7063 |
| Variance | 34.30586286 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1079 | |
| 13 | 101 | 6.2% |
| 5 | 100 | 6.2% |
| 4 | 61 | 3.8% |
| 22 | 60 | 3.7% |
| 15 | 47 | 2.9% |
| 6 | 37 | 2.3% |
| 14 | 27 | 1.7% |
| 9 | 15 | 0.9% |
| 8 | 14 | 0.9% |
| Other values (10) | 79 | 4.9% |
| Value | Count | Frequency (%) |
| 1 | 1079 | |
| 3 | 7 | 0.4% |
| 4 | 61 | 3.8% |
| 5 | 100 | 6.2% |
| 6 | 37 | 2.3% |
| 7 | 4 | 0.2% |
| 8 | 14 | 0.9% |
| 9 | 15 | 0.9% |
| 10 | 12 | 0.7% |
| 11 | 12 | 0.7% |
| Value | Count | Frequency (%) |
| 22 | 60 | |
| 21 | 13 | 0.8% |
| 20 | 1 | 0.1% |
| 18 | 12 | 0.7% |
| 17 | 5 | 0.3% |
| 16 | 1 | 0.1% |
| 15 | 47 | |
| 14 | 27 | 1.7% |
| 13 | 101 | |
| 12 | 12 | 0.7% |
| Distinct | 44 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.7604321 |
| Minimum | 6.3 |
|---|---|
| Maximum | 59 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 6.3 |
|---|---|
| 5-th percentile | 6.3 |
| Q1 | 6.3 |
| median | 6.3 |
| Q3 | 20 |
| 95-th percentile | 35 |
| Maximum | 59 |
| Range | 52.7 |
| Interquartile range (IQR) | 13.7 |
Descriptive statistics
| Standard deviation | 10.77819768 |
|---|---|
| Coefficient of variation (CV) | 0.8446577354 |
| Kurtosis | 1.574506315 |
| Mean | 12.7604321 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.546727874 |
| Sum | 20671.9 |
| Variance | 116.1695452 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.3 | 1123 | |
| 20 | 44 | 2.7% |
| 22 | 36 | 2.2% |
| 25 | 30 | 1.9% |
| 23 | 30 | 1.9% |
| 27 | 27 | 1.7% |
| 24 | 27 | 1.7% |
| 26 | 26 | 1.6% |
| 21 | 25 | 1.5% |
| 18 | 22 | 1.4% |
| Other values (34) | 230 | 14.2% |
| Value | Count | Frequency (%) |
| 6.3 | 1123 | |
| 14 | 2 | 0.1% |
| 15 | 2 | 0.1% |
| 16 | 5 | 0.3% |
| 17 | 13 | 0.8% |
| 18 | 22 | 1.4% |
| 19 | 21 | 1.3% |
| 20 | 44 | 2.7% |
| 21 | 25 | 1.5% |
| 22 | 36 | 2.2% |
| Value | Count | Frequency (%) |
| 59 | 1 | 0.1% |
| 57 | 1 | 0.1% |
| 56 | 1 | 0.1% |
| 53 | 2 | |
| 52 | 2 | |
| 51 | 3 | |
| 50 | 1 | 0.1% |
| 49 | 2 | |
| 48 | 4 | |
| 47 | 4 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| 2 | |
|---|---|
| 0 | |
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1620 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 1113 | |
| 0 | 268 | 16.5% |
| 1 | 239 | 14.8% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 2 | 1113 | |
| 0 | 268 | 16.5% |
| 1 | 239 | 14.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1113 | |
| 0 | 268 | 16.5% |
| 1 | 239 | 14.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 1113 | |
| 0 | 268 | 16.5% |
| 1 | 239 | 14.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 1113 | |
| 0 | 268 | 16.5% |
| 1 | 239 | 14.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 1113 | |
| 0 | 268 | 16.5% |
| 1 | 239 | 14.8% |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| 7 | |
|---|---|
| 4 | |
| 9 | |
| 3 | |
| 13 | 14 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.008641975 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1634 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 4 |
| 3rd row | 7 |
| 4th row | 7 |
| 5th row | 7 |
Common Values
| Value | Count | Frequency (%) |
| 7 | 1051 | |
| 4 | 225 | 13.9% |
| 9 | 200 | 12.3% |
| 3 | 130 | 8.0% |
| 13 | 14 | 0.9% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 7 | 1051 | |
| 4 | 225 | 13.9% |
| 9 | 200 | 12.3% |
| 3 | 130 | 8.0% |
| 13 | 14 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 1051 | |
| 4 | 225 | 13.8% |
| 9 | 200 | 12.2% |
| 3 | 144 | 8.8% |
| 1 | 14 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1634 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 1051 | |
| 4 | 225 | 13.8% |
| 9 | 200 | 12.2% |
| 3 | 144 | 8.8% |
| 1 | 14 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1634 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 7 | 1051 | |
| 4 | 225 | 13.8% |
| 9 | 200 | 12.2% |
| 3 | 144 | 8.8% |
| 1 | 14 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1634 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | 1051 | |
| 4 | 225 | 13.8% |
| 9 | 200 | 12.2% |
| 3 | 144 | 8.8% |
| 1 | 14 | 0.9% |
| Distinct | 636 |
|---|---|
| Distinct (%) | 39.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| Minimum | 2015-01-01 00:00:00 |
|---|---|
| Maximum | 2017-01-31 00:00:00 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| 0 | |
|---|---|
| 1 | 112 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1620 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 1508 | |
| 1 | 112 | 6.9% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 1508 | |
| 1 | 112 | 6.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1508 | |
| 1 | 112 | 6.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1508 | |
| 1 | 112 | 6.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1508 | |
| 1 | 112 | 6.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1508 | |
| 1 | 112 | 6.9% |
total_payment_channels
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 31 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.9308642 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 7 |
| median | 12 |
| Q3 | 17 |
| 95-th percentile | 23 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.306376705 |
|---|---|
| Coefficient of variation (CV) | 0.5285766899 |
| Kurtosis | -0.7384112912 |
| Mean | 11.9308642 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.2471306309 |
| Sum | 19328 |
| Variance | 39.77038715 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 106 | 6.5% |
| 8 | 97 | 6.0% |
| 14 | 88 | 5.4% |
| 17 | 88 | 5.4% |
| 13 | 86 | 5.3% |
| 16 | 85 | 5.2% |
| 15 | 83 | 5.1% |
| 7 | 83 | 5.1% |
| 3 | 79 | 4.9% |
| 5 | 74 | 4.6% |
| Other values (21) | 751 |
| Value | Count | Frequency (%) |
| 1 | 12 | 0.7% |
| 2 | 73 | |
| 3 | 79 | |
| 4 | 70 | |
| 5 | 74 | |
| 6 | 69 | |
| 7 | 83 | |
| 8 | 97 | |
| 9 | 106 | |
| 10 | 67 |
| Value | Count | Frequency (%) |
| 31 | 1 | 0.1% |
| 30 | 1 | 0.1% |
| 29 | 2 | 0.1% |
| 28 | 1 | 0.1% |
| 27 | 6 | 0.4% |
| 26 | 16 | |
| 25 | 16 | |
| 24 | 31 | |
| 23 | 21 | |
| 22 | 18 |
change_in_payment_methods
Categorical
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 5 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| 1 | |
|---|---|
| 2 | |
| 3 | 28 |
| 4 | 3 |
| 5 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1620 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 1428 | |
| 2 | 160 | 9.9% |
| 3 | 28 | 1.7% |
| 4 | 3 | 0.2% |
| 5 | 1 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 1428 | |
| 2 | 160 | 9.9% |
| 3 | 28 | 1.7% |
| 4 | 3 | 0.2% |
| 5 | 1 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1428 | |
| 2 | 160 | 9.9% |
| 3 | 28 | 1.7% |
| 4 | 3 | 0.2% |
| 5 | 1 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1428 | |
| 2 | 160 | 9.9% |
| 3 | 28 | 1.7% |
| 4 | 3 | 0.2% |
| 5 | 1 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 1428 | |
| 2 | 160 | 9.9% |
| 3 | 28 | 1.7% |
| 4 | 3 | 0.2% |
| 5 | 1 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 1428 | |
| 2 | 160 | 9.9% |
| 3 | 28 | 1.7% |
| 4 | 3 | 0.2% |
| 5 | 1 | 0.1% |
| Distinct | 142 |
|---|---|
| Distinct (%) | 8.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.27200278 |
| Minimum | 7 |
|---|---|
| Maximum | 410 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 28.69268775 |
| Q1 | 30 |
| median | 30 |
| Q3 | 30 |
| 95-th percentile | 33.34313725 |
| Maximum | 410 |
| Range | 403 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 21.00514917 |
|---|---|
| Coefficient of variation (CV) | 0.6508783889 |
| Kurtosis | 217.8071299 |
| Mean | 32.27200278 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.61431953 |
| Sum | 52280.6445 |
| Variance | 441.2162918 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 30 | 1372 | |
| 28.75 | 15 | 0.9% |
| 28.8 | 10 | 0.6% |
| 28.69565217 | 7 | 0.4% |
| 26.71428571 | 5 | 0.3% |
| 28.63636364 | 5 | 0.3% |
| 28.84615385 | 5 | 0.3% |
| 29 | 5 | 0.3% |
| 45 | 4 | 0.2% |
| 37.5 | 4 | 0.2% |
| Other values (132) | 188 | 11.6% |
| Value | Count | Frequency (%) |
| 7 | 1 | 0.1% |
| 12.66666667 | 1 | 0.1% |
| 18.14285714 | 1 | 0.1% |
| 18.5 | 2 | |
| 20.93548387 | 1 | 0.1% |
| 22.17391304 | 2 | |
| 22.33333333 | 4 | |
| 22.8 | 1 | 0.1% |
| 23.18181818 | 1 | 0.1% |
| 23.42857143 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 410 | 3 | |
| 302.5 | 1 | 0.1% |
| 195 | 2 | |
| 180 | 1 | 0.1% |
| 149 | 2 | |
| 147.5 | 1 | 0.1% |
| 135 | 1 | 0.1% |
| 132.3333333 | 1 | 0.1% |
| 125 | 1 | 0.1% |
| 120 | 2 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| 1 | |
|---|---|
| 2 | |
| 3 | 53 |
| 4 | 5 |
| 5 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1620 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 1382 | |
| 2 | 179 | 11.0% |
| 3 | 53 | 3.3% |
| 4 | 5 | 0.3% |
| 5 | 1 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 1382 | |
| 2 | 179 | 11.0% |
| 3 | 53 | 3.3% |
| 4 | 5 | 0.3% |
| 5 | 1 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1382 | |
| 2 | 179 | 11.0% |
| 3 | 53 | 3.3% |
| 4 | 5 | 0.3% |
| 5 | 1 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1382 | |
| 2 | 179 | 11.0% |
| 3 | 53 | 3.3% |
| 4 | 5 | 0.3% |
| 5 | 1 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 1382 | |
| 2 | 179 | 11.0% |
| 3 | 53 | 3.3% |
| 4 | 5 | 0.3% |
| 5 | 1 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 1382 | |
| 2 | 179 | 11.0% |
| 3 | 53 | 3.3% |
| 4 | 5 | 0.3% |
| 5 | 1 | 0.1% |
plan_list_price_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 291 |
|---|---|
| Distinct (%) | 18.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 133.6361603 |
| Minimum | 0 |
|---|---|
| Maximum | 1788 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 99 |
| Q1 | 99 |
| median | 112.9381818 |
| Q3 | 149 |
| 95-th percentile | 180 |
| Maximum | 1788 |
| Range | 1788 |
| Interquartile range (IQR) | 50 |
Descriptive statistics
| Standard deviation | 91.18492909 |
|---|---|
| Coefficient of variation (CV) | 0.6823372421 |
| Kurtosis | 208.4362207 |
| Mean | 133.6361603 |
| Median Absolute Deviation (MAD) | 13.93818182 |
| Skewness | 12.61208068 |
| Sum | 216490.5797 |
| Variance | 8314.691292 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99 | 740 | |
| 149 | 333 | |
| 180 | 89 | 5.5% |
| 129 | 26 | 1.6% |
| 100 | 19 | 1.2% |
| 143.04 | 9 | 0.6% |
| 142.7916667 | 9 | 0.6% |
| 139.6875 | 7 | 0.4% |
| 142.5217391 | 7 | 0.4% |
| 139 | 6 | 0.4% |
| Other values (281) | 375 |
| Value | Count | Frequency (%) |
| 0 | 1 | 0.1% |
| 24.83333333 | 1 | 0.1% |
| 74.5 | 2 | 0.1% |
| 77.14285714 | 1 | 0.1% |
| 87.96774194 | 1 | 0.1% |
| 90 | 1 | 0.1% |
| 92.8125 | 1 | 0.1% |
| 93.26086957 | 1 | 0.1% |
| 99 | 740 | |
| 99.06666667 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 1788 | 3 | |
| 894 | 2 | |
| 687 | 1 | 0.1% |
| 656 | 1 | 0.1% |
| 629.3333333 | 1 | 0.1% |
| 596 | 1 | 0.1% |
| 582 | 1 | 0.1% |
| 536 | 1 | 0.1% |
| 480 | 1 | 0.1% |
| 477 | 2 |
actual_amount_paid_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 287 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 133.1996603 |
| Minimum | 0 |
|---|---|
| Maximum | 1788 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 99 |
| Q1 | 99 |
| median | 111.75 |
| Q3 | 149 |
| 95-th percentile | 180 |
| Maximum | 1788 |
| Range | 1788 |
| Interquartile range (IQR) | 50 |
Descriptive statistics
| Standard deviation | 91.25875507 |
|---|---|
| Coefficient of variation (CV) | 0.685127536 |
| Kurtosis | 207.9944239 |
| Mean | 133.1996603 |
| Median Absolute Deviation (MAD) | 12.75 |
| Skewness | 12.59417892 |
| Sum | 215783.4497 |
| Variance | 8328.160377 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99 | 741 | |
| 149 | 356 | |
| 180 | 87 | 5.4% |
| 129 | 28 | 1.7% |
| 100 | 19 | 1.2% |
| 139 | 8 | 0.5% |
| 111.75 | 5 | 0.3% |
| 140.7222222 | 5 | 0.3% |
| 119.2 | 5 | 0.3% |
| 135.6666667 | 4 | 0.2% |
| Other values (277) | 362 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 24.83333333 | 1 | |
| 70.71428571 | 1 | |
| 74.5 | 2 | |
| 77 | 2 | |
| 77.14285714 | 1 | |
| 84.85714286 | 1 | |
| 86.625 | 1 | |
| 87.35294118 | 1 | |
| 87.41176471 | 1 |
| Value | Count | Frequency (%) |
| 1788 | 3 | |
| 894 | 2 | |
| 687 | 1 | 0.1% |
| 656 | 1 | 0.1% |
| 629.3333333 | 1 | 0.1% |
| 596 | 1 | 0.1% |
| 582 | 1 | 0.1% |
| 536 | 1 | 0.1% |
| 480 | 1 | 0.1% |
| 477 | 2 |
is_auto_renew_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 62 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8272474253 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 237 |
| Zeros (%) | 14.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3601876146 |
|---|---|
| Coefficient of variation (CV) | 0.4354049388 |
| Kurtosis | 1.22819203 |
| Mean | 0.8272474253 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.757435963 |
| Sum | 1340.140829 |
| Variance | 0.1297351177 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1255 | |
| 0 | 237 | 14.6% |
| 0.75 | 9 | 0.6% |
| 0.8 | 7 | 0.4% |
| 0.6666666667 | 7 | 0.4% |
| 0.5 | 7 | 0.4% |
| 0.8571428571 | 6 | 0.4% |
| 0.8333333333 | 6 | 0.4% |
| 0.4285714286 | 4 | 0.2% |
| 0.875 | 4 | 0.2% |
| Other values (52) | 78 | 4.8% |
| Value | Count | Frequency (%) |
| 0 | 237 | |
| 0.1 | 1 | 0.1% |
| 0.1333333333 | 1 | 0.1% |
| 0.1363636364 | 1 | 0.1% |
| 0.1538461538 | 1 | 0.1% |
| 0.1818181818 | 1 | 0.1% |
| 0.2 | 1 | 0.1% |
| 0.2142857143 | 1 | 0.1% |
| 0.2222222222 | 1 | 0.1% |
| 0.25 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1255 | |
| 0.9583333333 | 3 | 0.2% |
| 0.9545454545 | 1 | 0.1% |
| 0.9523809524 | 1 | 0.1% |
| 0.9444444444 | 3 | 0.2% |
| 0.9375 | 3 | 0.2% |
| 0.9333333333 | 1 | 0.1% |
| 0.9285714286 | 1 | 0.1% |
| 0.9230769231 | 1 | 0.1% |
| 0.92 | 1 | 0.1% |
is_autorenew_change_flag
Categorical
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1620 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 1383 | |
| 0 | 237 | 14.6% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 1383 | |
| 0 | 237 | 14.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1383 | |
| 0 | 237 | 14.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1383 | |
| 0 | 237 | 14.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 1383 | |
| 0 | 237 | 14.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 1383 | |
| 0 | 237 | 14.6% |
| Distinct | 632 |
|---|---|
| Distinct (%) | 39.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| Minimum | 2015-01-01 00:00:00 |
|---|---|
| Maximum | 2017-01-31 00:00:00 |
| Distinct | 85 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| Minimum | 2015-12-15 00:00:00 |
|---|---|
| Maximum | 2017-02-28 00:00:00 |
total_transactions
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 31 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.9308642 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 7 |
| median | 12 |
| Q3 | 17 |
| 95-th percentile | 23 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.306376705 |
|---|---|
| Coefficient of variation (CV) | 0.5285766899 |
| Kurtosis | -0.7384112912 |
| Mean | 11.9308642 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.2471306309 |
| Sum | 19328 |
| Variance | 39.77038715 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 106 | 6.5% |
| 8 | 97 | 6.0% |
| 14 | 88 | 5.4% |
| 17 | 88 | 5.4% |
| 13 | 86 | 5.3% |
| 16 | 85 | 5.2% |
| 15 | 83 | 5.1% |
| 7 | 83 | 5.1% |
| 3 | 79 | 4.9% |
| 5 | 74 | 4.6% |
| Other values (21) | 751 |
| Value | Count | Frequency (%) |
| 1 | 12 | 0.7% |
| 2 | 73 | |
| 3 | 79 | |
| 4 | 70 | |
| 5 | 74 | |
| 6 | 69 | |
| 7 | 83 | |
| 8 | 97 | |
| 9 | 106 | |
| 10 | 67 |
| Value | Count | Frequency (%) |
| 31 | 1 | 0.1% |
| 30 | 1 | 0.1% |
| 29 | 2 | 0.1% |
| 28 | 1 | 0.1% |
| 27 | 6 | 0.4% |
| 26 | 16 | |
| 25 | 16 | |
| 24 | 31 | |
| 23 | 21 | |
| 22 | 18 |
| Distinct | 59 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| Minimum | 2017-02-01 00:00:00 |
|---|---|
| Maximum | 2017-03-31 00:00:00 |
is_cancel_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 37 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01248799314 |
| Minimum | 0 |
|---|---|
| Maximum | 0.5 |
| Zeros | 1395 |
| Zeros (%) | 86.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.08333333333 |
| Maximum | 0.5 |
| Range | 0.5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.03930297574 |
|---|---|
| Coefficient of variation (CV) | 3.147261157 |
| Kurtosis | 43.16468295 |
| Mean | 0.01248799314 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.353976071 |
| Sum | 20.23054889 |
| Variance | 0.001544723902 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1395 | |
| 0.07142857143 | 20 | 1.2% |
| 0.05555555556 | 17 | 1.0% |
| 0.0625 | 15 | 0.9% |
| 0.1 | 14 | 0.9% |
| 0.09090909091 | 12 | 0.7% |
| 0.07692307692 | 12 | 0.7% |
| 0.05263157895 | 12 | 0.7% |
| 0.06666666667 | 11 | 0.7% |
| 0.125 | 10 | 0.6% |
| Other values (27) | 102 | 6.3% |
| Value | Count | Frequency (%) |
| 0 | 1395 | |
| 0.03703703704 | 1 | 0.1% |
| 0.03846153846 | 3 | 0.2% |
| 0.04 | 7 | 0.4% |
| 0.04166666667 | 7 | 0.4% |
| 0.04347826087 | 4 | 0.2% |
| 0.04545454545 | 4 | 0.2% |
| 0.04761904762 | 8 | 0.5% |
| 0.05 | 8 | 0.5% |
| 0.05263157895 | 12 | 0.7% |
| Value | Count | Frequency (%) |
| 0.5 | 2 | 0.1% |
| 0.3333333333 | 3 | |
| 0.2857142857 | 1 | 0.1% |
| 0.25 | 3 | |
| 0.2142857143 | 1 | 0.1% |
| 0.2 | 3 | |
| 0.1818181818 | 2 | 0.1% |
| 0.1724137931 | 1 | 0.1% |
| 0.1666666667 | 5 | |
| 0.1538461538 | 1 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1620 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 1395 | |
| 1 | 225 | 13.9% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 1395 | |
| 1 | 225 | 13.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1395 | |
| 1 | 225 | 13.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1395 | |
| 1 | 225 | 13.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1395 | |
| 1 | 225 | 13.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1395 | |
| 1 | 225 | 13.9% |
discount_mean
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 80 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.436500008 |
| Minimum | -38.86956522 |
|---|---|
| Maximum | 90 |
| Zeros | 1438 |
| Zeros (%) | 88.8% |
| Negative | 91 |
| Negative (%) | 5.6% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -38.86956522 |
|---|---|
| 5-th percentile | -5.382175926 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 5.730769231 |
| Maximum | 90 |
| Range | 128.8695652 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5.801866399 |
|---|---|
| Coefficient of variation (CV) | 13.2917899 |
| Kurtosis | 60.03643088 |
| Mean | 0.436500008 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.665131468 |
| Sum | 707.1300129 |
| Variance | 33.66165371 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1438 | |
| -6.208333333 | 11 | 0.7% |
| -5.96 | 10 | 0.6% |
| -5.730769231 | 7 | 0.4% |
| 14.9 | 6 | 0.4% |
| -5.375 | 6 | 0.4% |
| -6.47826087 | 5 | 0.3% |
| 8.277777778 | 5 | 0.3% |
| 18.625 | 5 | 0.3% |
| 16.55555556 | 4 | 0.2% |
| Other values (70) | 123 | 7.6% |
| Value | Count | Frequency (%) |
| -38.86956522 | 2 | |
| -35.76 | 1 | |
| -32.95454545 | 1 | |
| -27.59259259 | 1 | |
| -24.83333333 | 1 | |
| -22.35 | 1 | |
| -18.625 | 1 | |
| -15.68421053 | 1 | |
| -13.54545455 | 2 | |
| -12.41666667 | 1 |
| Value | Count | Frequency (%) |
| 90 | 1 | 0.1% |
| 60 | 1 | 0.1% |
| 50 | 1 | 0.1% |
| 42.57142857 | 2 | |
| 37.25 | 3 | |
| 33.11111111 | 3 | |
| 31.92857143 | 1 | 0.1% |
| 29.8 | 4 | |
| 27.09090909 | 1 | 0.1% |
| 24.83333333 | 1 | 0.1% |
is_discount_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 46 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.008801214038 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 1520 |
| Zeros (%) | 93.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.04773809524 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.04973378859 |
|---|---|
| Coefficient of variation (CV) | 5.650787309 |
| Kurtosis | 144.2724941 |
| Mean | 0.008801214038 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.17689583 |
| Sum | 14.25796674 |
| Variance | 0.002473449728 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1520 | |
| 0.04347826087 | 6 | 0.4% |
| 0.1 | 6 | 0.4% |
| 0.125 | 5 | 0.3% |
| 0.05555555556 | 5 | 0.3% |
| 0.1111111111 | 4 | 0.2% |
| 0.09090909091 | 4 | 0.2% |
| 0.2 | 4 | 0.2% |
| 0.25 | 4 | 0.2% |
| 0.05263157895 | 4 | 0.2% |
| Other values (36) | 58 | 3.6% |
| Value | Count | Frequency (%) |
| 0 | 1520 | |
| 0.03333333333 | 1 | 0.1% |
| 0.03703703704 | 1 | 0.1% |
| 0.03846153846 | 4 | 0.2% |
| 0.04 | 1 | 0.1% |
| 0.04166666667 | 3 | 0.2% |
| 0.04347826087 | 6 | 0.4% |
| 0.04545454545 | 2 | 0.1% |
| 0.04761904762 | 1 | 0.1% |
| 0.05 | 3 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 0.6363636364 | 2 | |
| 0.5 | 1 | |
| 0.4090909091 | 1 | |
| 0.3636363636 | 1 | |
| 0.3333333333 | 1 | |
| 0.3076923077 | 1 | |
| 0.2916666667 | 1 | |
| 0.2857142857 | 2 | |
| 0.28 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| 0 | |
|---|---|
| 1 | 100 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1620 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 1520 | |
| 1 | 100 | 6.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 1520 | |
| 1 | 100 | 6.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1520 | |
| 1 | 100 | 6.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1620 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1520 | |
| 1 | 100 | 6.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1620 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1520 | |
| 1 | 100 | 6.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1620 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1520 | |
| 1 | 100 | 6.2% |
| Distinct | 321 |
|---|---|
| Distinct (%) | 19.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.081865522 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.3 |
| Q1 | 3.3 |
| median | 3.526573751 |
| Q3 | 4.966666667 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1.666666667 |
Descriptive statistics
| Standard deviation | 0.9029994755 |
|---|---|
| Coefficient of variation (CV) | 0.2212222501 |
| Kurtosis | -0.6878973932 |
| Mean | 4.081865522 |
| Median Absolute Deviation (MAD) | 0.3801722803 |
| Skewness | 0.4313038117 |
| Sum | 6612.622146 |
| Variance | 0.8154080527 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.3 | 652 | |
| 4.966666667 | 296 | |
| 3.3 | 89 | 5.5% |
| 6 | 87 | 5.4% |
| 4.3 | 26 | 1.6% |
| 3.333333333 | 19 | 1.2% |
| 4.690740741 | 7 | 0.4% |
| 3.973333333 | 6 | 0.4% |
| 4.768 | 6 | 0.4% |
| 4.759722222 | 6 | 0.4% |
| Other values (311) | 426 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.8277777778 | 1 | |
| 1.503917379 | 1 | |
| 2.292307692 | 1 | |
| 2.357142857 | 1 | |
| 2.483333333 | 2 | |
| 2.564769648 | 1 | |
| 2.566666667 | 2 | |
| 2.571428571 | 1 | |
| 2.828571429 | 1 |
| Value | Count | Frequency (%) |
| 6 | 87 | |
| 5.9 | 2 | 0.1% |
| 5.890909091 | 1 | 0.1% |
| 5.888888889 | 1 | 0.1% |
| 5.854761905 | 1 | 0.1% |
| 5.850997783 | 1 | 0.1% |
| 5.846153846 | 1 | 0.1% |
| 5.842735043 | 1 | 0.1% |
| 5.833333333 | 1 | 0.1% |
| 5.8 | 3 | 0.2% |
| Distinct | 459 |
|---|---|
| Distinct (%) | 28.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.31085938 |
| Minimum | -4273.25 |
|---|---|
| Maximum | 414 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | 0.1% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | -4273.25 |
|---|---|
| 5-th percentile | 27.24903846 |
| Q1 | 29.98 |
| median | 30.3125 |
| Q3 | 30.42105263 |
| 95-th percentile | 42.20666667 |
| Maximum | 414 |
| Range | 4687.25 |
| Interquartile range (IQR) | 0.4410526316 |
Descriptive statistics
| Standard deviation | 109.042384 |
|---|---|
| Coefficient of variation (CV) | 3.597469232 |
| Kurtosis | 1501.452087 |
| Mean | 30.31085938 |
| Median Absolute Deviation (MAD) | 0.2430555556 |
| Skewness | -37.92216912 |
| Sum | 49103.5922 |
| Variance | 11890.24151 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 30 | 135 | 8.3% |
| 30.33333333 | 83 | 5.1% |
| 30.375 | 60 | 3.7% |
| 30.4 | 53 | 3.3% |
| 29 | 46 | 2.8% |
| 30.28571429 | 43 | 2.7% |
| 30.41176471 | 36 | 2.2% |
| 30.30769231 | 33 | 2.0% |
| 30.25 | 33 | 2.0% |
| 30.42105263 | 29 | 1.8% |
| Other values (449) | 1069 |
| Value | Count | Frequency (%) |
| -4273.25 | 1 | |
| 7 | 1 | |
| 12.375 | 1 | |
| 15 | 1 | |
| 16.5 | 1 | |
| 17.25 | 1 | |
| 17.5 | 1 | |
| 18 | 2 | |
| 18.33333333 | 1 | |
| 18.5 | 1 |
| Value | Count | Frequency (%) |
| 414 | 1 | |
| 413 | 1 | |
| 411 | 1 | |
| 197.6666667 | 1 | |
| 196.5 | 1 | |
| 195 | 1 | |
| 189 | 1 | |
| 180 | 1 | |
| 150.3333333 | 1 | |
| 147.3333333 | 1 |
more_than_30_sum
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 24 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.716049383 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 210 |
| Zeros (%) | 13.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 9 |
| 95-th percentile | 13 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.297850039 |
|---|---|
| Coefficient of variation (CV) | 0.7518916915 |
| Kurtosis | 0.2541138802 |
| Mean | 5.716049383 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.5507513391 |
| Sum | 9260 |
| Variance | 18.47151496 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 210 | |
| 1 | 152 | |
| 5 | 137 | |
| 9 | 133 | |
| 7 | 132 | |
| 2 | 123 | 7.6% |
| 10 | 117 | 7.2% |
| 6 | 108 | 6.7% |
| 4 | 101 | 6.2% |
| 3 | 98 | 6.0% |
| Other values (14) | 309 |
| Value | Count | Frequency (%) |
| 0 | 210 | |
| 1 | 152 | |
| 2 | 123 | |
| 3 | 98 | |
| 4 | 101 | |
| 5 | 137 | |
| 6 | 108 | |
| 7 | 132 | |
| 8 | 91 | |
| 9 | 133 |
| Value | Count | Frequency (%) |
| 30 | 1 | 0.1% |
| 26 | 1 | 0.1% |
| 21 | 1 | 0.1% |
| 20 | 1 | 0.1% |
| 19 | 2 | 0.1% |
| 18 | 9 | 0.6% |
| 17 | 2 | 0.1% |
| 16 | 6 | 0.4% |
| 15 | 5 | 0.3% |
| 14 | 35 |
| Distinct | 1290 |
|---|---|
| Distinct (%) | 79.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.079500914 |
| Minimum | 0 |
|---|---|
| Maximum | 5.003946304 |
| Zeros | 70 |
| Zeros (%) | 4.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1149469078 |
| Q1 | 0.5556846708 |
| median | 0.9921378791 |
| Q3 | 1.484854251 |
| 95-th percentile | 2.387628365 |
| Maximum | 5.003946304 |
| Range | 5.003946304 |
| Interquartile range (IQR) | 0.9291695803 |
Descriptive statistics
| Standard deviation | 0.7032536268 |
|---|---|
| Coefficient of variation (CV) | 0.6514618397 |
| Kurtosis | 1.182220221 |
| Mean | 1.079500914 |
| Median Absolute Deviation (MAD) | 0.4566862583 |
| Skewness | 0.8732081056 |
| Sum | 1748.791504 |
| Variance | 0.4945656955 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 70 | 4.3% |
| 0.1732867956 | 28 | 1.7% |
| 0.3465735912 | 22 | 1.4% |
| 0.2746530771 | 15 | 0.9% |
| 0.4023594856 | 13 | 0.8% |
| 0.4479398727 | 12 | 0.7% |
| 0.6931471825 | 10 | 0.6% |
| 0.794513464 | 9 | 0.6% |
| 0.6212266684 | 9 | 0.6% |
| 0.2310490608 | 8 | 0.5% |
| Other values (1280) | 1424 |
| Value | Count | Frequency (%) |
| 0 | 70 | |
| 0.05776226521 | 2 | 0.1% |
| 0.07701635361 | 1 | 0.1% |
| 0.08664339781 | 5 | 0.3% |
| 0.09155102819 | 1 | 0.1% |
| 0.1005898714 | 1 | 0.1% |
| 0.1039720774 | 1 | 0.1% |
| 0.1155245304 | 5 | 0.3% |
| 0.1204321608 | 1 | 0.1% |
| 0.121471338 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 5.003946304 | 1 | |
| 4.140595436 | 1 | |
| 3.867604733 | 1 | |
| 3.812770605 | 1 | |
| 3.771541119 | 1 | |
| 3.736549139 | 1 | |
| 3.527849913 | 1 | |
| 3.522888184 | 1 | |
| 3.456262112 | 1 | |
| 3.423892498 | 1 |
| Distinct | 823 |
|---|---|
| Distinct (%) | 50.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3590388298 |
| Minimum | 0 |
|---|---|
| Maximum | 2.708050251 |
| Zeros | 265 |
| Zeros (%) | 16.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.1155245304 |
| median | 0.2746530771 |
| Q3 | 0.5198603868 |
| 95-th percentile | 1.047928405 |
| Maximum | 2.708050251 |
| Range | 2.708050251 |
| Interquartile range (IQR) | 0.4043358564 |
Descriptive statistics
| Standard deviation | 0.3483375907 |
|---|---|
| Coefficient of variation (CV) | 0.970194757 |
| Kurtosis | 4.850337982 |
| Mean | 0.3590388298 |
| Median Absolute Deviation (MAD) | 0.1880096793 |
| Skewness | 1.749609113 |
| Sum | 581.6428833 |
| Variance | 0.1213390753 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 265 | 16.4% |
| 0.1732867956 | 81 | 5.0% |
| 0.08664339781 | 33 | 2.0% |
| 0.3465735912 | 30 | 1.9% |
| 0.1155245304 | 22 | 1.4% |
| 0.2310490608 | 21 | 1.3% |
| 0.2746530771 | 19 | 1.2% |
| 0.05776226521 | 18 | 1.1% |
| 0.5198603868 | 13 | 0.8% |
| 0.4479398727 | 12 | 0.7% |
| Other values (813) | 1106 |
| Value | Count | Frequency (%) |
| 0 | 265 | |
| 0.02475525625 | 3 | 0.2% |
| 0.02746530809 | 1 | 0.1% |
| 0.0288811326 | 3 | 0.2% |
| 0.03465735912 | 5 | 0.3% |
| 0.0385081768 | 1 | 0.1% |
| 0.0433216989 | 4 | 0.2% |
| 0.0457755141 | 2 | 0.1% |
| 0.04620981216 | 1 | 0.1% |
| 0.04726003483 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 2.708050251 | 1 | |
| 2.397895336 | 1 | |
| 2.237657309 | 1 | |
| 2.215408325 | 1 | |
| 2.138333082 | 1 | |
| 2.079441547 | 1 | |
| 2.050125837 | 1 | |
| 1.88765347 | 1 | |
| 1.821205258 | 1 | |
| 1.818099618 | 1 |
| Distinct | 601 |
|---|---|
| Distinct (%) | 37.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2241915166 |
| Minimum | 0 |
|---|---|
| Maximum | 2.564949274 |
| Zeros | 410 |
| Zeros (%) | 25.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.1732867956 |
| Q3 | 0.3157505095 |
| 95-th percentile | 0.6932374895 |
| Maximum | 2.564949274 |
| Range | 2.564949274 |
| Interquartile range (IQR) | 0.3157505095 |
Descriptive statistics
| Standard deviation | 0.2568334043 |
|---|---|
| Coefficient of variation (CV) | 1.145598173 |
| Kurtosis | 10.52245426 |
| Mean | 0.2241915166 |
| Median Absolute Deviation (MAD) | 0.1490656137 |
| Skewness | 2.406011105 |
| Sum | 363.1902466 |
| Variance | 0.06596340239 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 410 | |
| 0.1732867956 | 77 | 4.8% |
| 0.08664339781 | 46 | 2.8% |
| 0.1155245304 | 38 | 2.3% |
| 0.05776226521 | 29 | 1.8% |
| 0.3465735912 | 27 | 1.7% |
| 0.2746530771 | 25 | 1.5% |
| 0.2310490608 | 25 | 1.5% |
| 0.09155102819 | 14 | 0.9% |
| 0.1386294365 | 13 | 0.8% |
| Other values (591) | 916 |
| Value | Count | Frequency (%) |
| 0 | 410 | |
| 0.0144405663 | 1 | 0.1% |
| 0.0192540884 | 1 | 0.1% |
| 0.02166084945 | 1 | 0.1% |
| 0.02475525625 | 5 | 0.3% |
| 0.0288811326 | 10 | 0.6% |
| 0.03465735912 | 9 | 0.6% |
| 0.0385081768 | 3 | 0.2% |
| 0.03923615441 | 1 | 0.1% |
| 0.0433216989 | 11 | 0.7% |
| Value | Count | Frequency (%) |
| 2.564949274 | 1 | |
| 2.302585125 | 1 | |
| 1.766829133 | 1 | |
| 1.763180256 | 1 | |
| 1.465654254 | 1 | |
| 1.386294365 | 2 | |
| 1.370159745 | 1 | |
| 1.305276513 | 1 | |
| 1.297273517 | 1 | |
| 1.292621017 | 1 |
| Distinct | 607 |
|---|---|
| Distinct (%) | 37.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2246976197 |
| Minimum | 0 |
|---|---|
| Maximum | 2.079441547 |
| Zeros | 405 |
| Zeros (%) | 25.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.01083042473 |
| median | 0.1732867956 |
| Q3 | 0.3226000965 |
| 95-th percentile | 0.7324753463 |
| Maximum | 2.079441547 |
| Range | 2.079441547 |
| Interquartile range (IQR) | 0.3117696717 |
Descriptive statistics
| Standard deviation | 0.2528685033 |
|---|---|
| Coefficient of variation (CV) | 1.12537241 |
| Kurtosis | 5.4888978 |
| Mean | 0.2246976197 |
| Median Absolute Deviation (MAD) | 0.1493133008 |
| Skewness | 1.953810692 |
| Sum | 364.0101318 |
| Variance | 0.06394248456 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 405 | |
| 0.1732867956 | 87 | 5.4% |
| 0.08664339781 | 42 | 2.6% |
| 0.05776226521 | 35 | 2.2% |
| 0.2310490608 | 29 | 1.8% |
| 0.1155245304 | 26 | 1.6% |
| 0.2746530771 | 24 | 1.5% |
| 0.3465735912 | 23 | 1.4% |
| 0.2239699364 | 18 | 1.1% |
| 0.4479398727 | 15 | 0.9% |
| Other values (597) | 916 |
| Value | Count | Frequency (%) |
| 0 | 405 | |
| 0.0144405663 | 1 | 0.1% |
| 0.02166084945 | 1 | 0.1% |
| 0.02475525625 | 3 | 0.2% |
| 0.0288811326 | 5 | 0.3% |
| 0.03300700709 | 2 | 0.1% |
| 0.03465735912 | 11 | 0.7% |
| 0.0385081768 | 3 | 0.2% |
| 0.03923615441 | 2 | 0.1% |
| 0.04072180763 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 2.079441547 | 1 | |
| 1.784716845 | 1 | |
| 1.42594564 | 1 | |
| 1.386294365 | 1 | |
| 1.360248685 | 1 | |
| 1.319528699 | 1 | |
| 1.316468716 | 1 | |
| 1.31267333 | 1 | |
| 1.298239231 | 1 | |
| 1.283491373 | 1 |
| Distinct | 1553 |
|---|---|
| Distinct (%) | 95.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.400013208 |
| Minimum | 0 |
|---|---|
| Maximum | 5.924189091 |
| Zeros | 22 |
| Zeros (%) | 1.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.8953939259 |
| Q1 | 1.886082977 |
| median | 2.418399572 |
| Q3 | 2.946542084 |
| 95-th percentile | 3.805382395 |
| Maximum | 5.924189091 |
| Range | 5.924189091 |
| Interquartile range (IQR) | 1.060459107 |
Descriptive statistics
| Standard deviation | 0.8693374395 |
|---|---|
| Coefficient of variation (CV) | 0.3622219265 |
| Kurtosis | 0.5379921794 |
| Mean | 2.400013208 |
| Median Absolute Deviation (MAD) | 0.5311615467 |
| Skewness | -0.05542365834 |
| Sum | 3888.021484 |
| Variance | 0.7557476163 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 22 | 1.4% |
| 0.6931471825 | 6 | 0.4% |
| 0.7225929499 | 3 | 0.2% |
| 1.471526027 | 3 | 0.2% |
| 1.555644035 | 3 | 0.2% |
| 0.8958797455 | 3 | 0.2% |
| 0.8664339781 | 3 | 0.2% |
| 0.2746530771 | 3 | 0.2% |
| 1.023586154 | 2 | 0.1% |
| 0.5198603868 | 2 | 0.1% |
| Other values (1543) | 1570 |
| Value | Count | Frequency (%) |
| 0 | 22 | |
| 0.2310490608 | 1 | 0.1% |
| 0.2746530771 | 3 | 0.2% |
| 0.3080654144 | 1 | 0.1% |
| 0.3465735912 | 1 | 0.1% |
| 0.3662041128 | 2 | 0.1% |
| 0.4023594856 | 1 | 0.1% |
| 0.4305278957 | 1 | 0.1% |
| 0.4479398727 | 2 | 0.1% |
| 0.4864775538 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 5.924189091 | 1 | |
| 5.481370449 | 1 | |
| 5.224838734 | 1 | |
| 5.098548412 | 1 | |
| 4.954596043 | 1 | |
| 4.903764725 | 1 | |
| 4.890113831 | 1 | |
| 4.885931015 | 1 | |
| 4.880422115 | 1 | |
| 4.84425354 | 1 |
| Distinct | 1579 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.621389151 |
| Minimum | 0 |
|---|---|
| Maximum | 5.257495403 |
| Zeros | 5 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.314168793 |
| Q1 | 2.181361258 |
| median | 2.659072638 |
| Q3 | 3.083636224 |
| 95-th percentile | 3.811152709 |
| Maximum | 5.257495403 |
| Range | 5.257495403 |
| Interquartile range (IQR) | 0.9022749662 |
Descriptive statistics
| Standard deviation | 0.7503094673 |
|---|---|
| Coefficient of variation (CV) | 0.2862258852 |
| Kurtosis | 0.6455993056 |
| Mean | 2.621389151 |
| Median Absolute Deviation (MAD) | 0.4508309364 |
| Skewness | -0.2068370581 |
| Sum | 4246.650391 |
| Variance | 0.5629643202 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.6931471825 | 7 | 0.4% |
| 0 | 5 | 0.3% |
| 2.059369802 | 4 | 0.2% |
| 1.098612309 | 3 | 0.2% |
| 0.8958797455 | 3 | 0.2% |
| 1.818099618 | 3 | 0.2% |
| 0.5972531438 | 3 | 0.2% |
| 1.059351325 | 3 | 0.2% |
| 1.370159745 | 2 | 0.1% |
| 0.7489330769 | 2 | 0.1% |
| Other values (1569) | 1585 |
| Value | Count | Frequency (%) |
| 0 | 5 | |
| 0.1732867956 | 1 | 0.1% |
| 0.3465735912 | 2 | 0.1% |
| 0.5493061543 | 2 | 0.1% |
| 0.5972531438 | 3 | |
| 0.6212266684 | 1 | 0.1% |
| 0.6770125628 | 1 | 0.1% |
| 0.6931471825 | 7 | |
| 0.7489330769 | 2 | 0.1% |
| 0.7739418149 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 5.257495403 | 1 | |
| 4.943751335 | 1 | |
| 4.847590446 | 1 | |
| 4.794824123 | 1 | |
| 4.755366325 | 1 | |
| 4.738386631 | 1 | |
| 4.723978043 | 1 | |
| 4.69779253 | 1 | |
| 4.625041008 | 1 | |
| 4.53429842 | 1 |
| Distinct | 583 |
|---|---|
| Distinct (%) | 36.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.0078125 |
| Minimum | 0.9223632812 |
|---|---|
| Maximum | 10.890625 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.3 KiB |
Quantile statistics
| Minimum | 0.9223632812 |
|---|---|
| 5-th percentile | 6.464453125 |
| Q1 | 7.549804688 |
| median | 8.0625 |
| Q3 | 8.5625 |
| 95-th percentile | 9.351953125 |
| Maximum | 10.890625 |
| Range | 9.968261719 |
| Interquartile range (IQR) | 1.012695312 |
Descriptive statistics
| Standard deviation | 0.9106445312 |
|---|---|
| Coefficient of variation (CV) | 0.1137084961 |
| Kurtosis | 4.74609375 |
| Mean | 8.0078125 |
| Median Absolute Deviation (MAD) | 0.5078125 |
| Skewness | -1.012695312 |
| Sum | 12976 |
| Variance | 0.8291015625 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8.0703125 | 11 | 0.7% |
| 8.125 | 11 | 0.7% |
| 8.109375 | 10 | 0.6% |
| 8.265625 | 10 | 0.6% |
| 8.2109375 | 10 | 0.6% |
| 8.03125 | 10 | 0.6% |
| 8.1640625 | 10 | 0.6% |
| 8.3515625 | 9 | 0.6% |
| 8.234375 | 9 | 0.6% |
| 8.5 | 9 | 0.6% |
| Other values (573) | 1521 |
| Value | Count | Frequency (%) |
| 0.9223632812 | 1 | |
| 2.8984375 | 1 | |
| 3.55078125 | 1 | |
| 3.6953125 | 1 | |
| 3.70703125 | 1 | |
| 3.7421875 | 1 | |
| 3.77734375 | 1 | |
| 3.99609375 | 1 | |
| 4.4375 | 1 | |
| 4.625 | 1 |
| Value | Count | Frequency (%) |
| 10.890625 | 1 | |
| 10.6328125 | 1 | |
| 10.6015625 | 1 | |
| 10.4375 | 1 | |
| 10.421875 | 1 | |
| 10.40625 | 1 | |
| 10.375 | 1 | |
| 10.328125 | 1 | |
| 10.203125 | 1 | |
| 10.1875 | 1 |
| Distinct | 49 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.08271605 |
| Minimum | 1 |
|---|---|
| Maximum | 60 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 12 |
| Q3 | 21 |
| 95-th percentile | 39 |
| Maximum | 60 |
| Range | 59 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 11.50644785 |
|---|---|
| Coefficient of variation (CV) | 0.7628896424 |
| Kurtosis | 0.4466703241 |
| Mean | 15.08271605 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.024195927 |
| Sum | 24434 |
| Variance | 132.3983422 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 298 | |
| 12 | 190 | |
| 8 | 177 | |
| 20 | 110 | 6.8% |
| 16 | 106 | 6.5% |
| 24 | 93 | 5.7% |
| 28 | 73 | 4.5% |
| 3 | 70 | 4.3% |
| 32 | 54 | 3.3% |
| 6 | 49 | 3.0% |
| Other values (39) | 400 |
| Value | Count | Frequency (%) |
| 1 | 23 | 1.4% |
| 2 | 24 | 1.5% |
| 3 | 70 | 4.3% |
| 4 | 298 | |
| 5 | 15 | 0.9% |
| 6 | 49 | 3.0% |
| 7 | 5 | 0.3% |
| 8 | 177 | |
| 9 | 32 | 2.0% |
| 10 | 9 | 0.6% |
| Value | Count | Frequency (%) |
| 60 | 1 | 0.1% |
| 56 | 1 | 0.1% |
| 52 | 9 | 0.6% |
| 48 | 13 | |
| 46 | 2 | 0.1% |
| 45 | 2 | 0.1% |
| 44 | 23 | |
| 43 | 1 | 0.1% |
| 42 | 1 | 0.1% |
| 41 | 1 | 0.1% |
last_login
Date
| Distinct | 275 |
|---|---|
| Distinct (%) | 17.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.8 KiB |
| Minimum | 2015-02-27 00:00:00 |
|---|---|
| Maximum | 2017-02-28 00:00:00 |
registration_duration
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 454 |
|---|---|
| Distinct (%) | 28.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 403.6481481 |
| Minimum | 14 |
|---|---|
| Maximum | 809 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 14 |
|---|---|
| 5-th percentile | 89 |
| Q1 | 243 |
| median | 408.5 |
| Q3 | 547 |
| 95-th percentile | 745 |
| Maximum | 809 |
| Range | 795 |
| Interquartile range (IQR) | 304 |
Descriptive statistics
| Standard deviation | 195.3883345 |
|---|---|
| Coefficient of variation (CV) | 0.4840560657 |
| Kurtosis | -0.8639791412 |
| Mean | 403.6481481 |
| Median Absolute Deviation (MAD) | 151 |
| Skewness | 0.0512464614 |
| Sum | 653910 |
| Variance | 38176.60126 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 517 | 42 | 2.6% |
| 394 | 35 | 2.2% |
| 578 | 33 | 2.0% |
| 393 | 31 | 1.9% |
| 609 | 31 | 1.9% |
| 272 | 30 | 1.9% |
| 242 | 29 | 1.8% |
| 89 | 29 | 1.8% |
| 425 | 28 | 1.7% |
| 455 | 28 | 1.7% |
| Other values (444) | 1304 |
| Value | Count | Frequency (%) |
| 14 | 1 | 0.1% |
| 30 | 1 | 0.1% |
| 34 | 1 | 0.1% |
| 35 | 1 | 0.1% |
| 36 | 1 | 0.1% |
| 52 | 1 | 0.1% |
| 58 | 20 | |
| 59 | 5 | 0.3% |
| 60 | 1 | 0.1% |
| 61 | 4 | 0.2% |
| Value | Count | Frequency (%) |
| 809 | 1 | 0.1% |
| 807 | 1 | 0.1% |
| 805 | 1 | 0.1% |
| 801 | 2 | |
| 799 | 1 | 0.1% |
| 798 | 2 | |
| 797 | 2 | |
| 796 | 1 | 0.1% |
| 795 | 1 | 0.1% |
| 793 | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | msno | city | bd | gender | registered_via | registration_init_time | is_churn | total_payment_channels | change_in_payment_methods | payment_plan_days_mean | change_in_plan | plan_list_price_mean | actual_amount_paid_mean | is_auto_renew_mean | is_autorenew_change_flag | transaction_date_min | transaction_date_max | total_transactions | membership_expire_date_max | is_cancel_mean | is_cancel_change_flag | discount_mean | is_discount_mean | is_discount_max | amt_per_day_mean | membership_duration_mean | more_than_30_sum | num_25 | num_50 | num_75 | num_985 | num_100 | num_unq | total_secs | login_freq | last_login | registration_duration | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 97370 | w8s1oZwdZVugLhPzRsSmfFBeniLGowuLi7NgY9FCq44= | 13 | 6.3 | 0 | 4 | 2016-01-30 | 1 | 2 | 2 | 18.500000 | 2 | 90.000000 | 90.000000 | 0.0 | 0 | 2016-11-16 | 2017-01-15 | 2 | 2017-02-14 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 3.000000 | 18.500000 | 0 | 0.173287 | 0.000000 | 0.000000 | 0.000000 | 3.299368 | 3.353329 | 8.929688 | 4 | 2017-02-11 | 381 |
| 1 | 100926 | cnncNsMOZE3kiTKQNSBbVCJMdE+PKr56pBYYeHWJ8Zk= | 6 | 30.0 | 0 | 4 | 2016-02-06 | 0 | 13 | 1 | 30.000000 | 1 | 149.000000 | 149.000000 | 1.0 | 1 | 2016-02-12 | 2017-02-12 | 13 | 2017-03-11 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 4.966667 | 29.307692 | 0 | 0.183102 | 0.000000 | 0.000000 | 0.000000 | 3.335215 | 3.347396 | 8.757812 | 6 | 2016-10-05 | 399 |
| 2 | 66560 | aWZDoNfiZtG0IWeC0++ocJXLZORBwDvkYA2rCBA4yAs= | 1 | 6.3 | 2 | 7 | 2015-12-20 | 0 | 15 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.0 | 1 | 2015-12-20 | 2017-02-20 | 15 | 2017-03-20 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.400000 | 9 | 2.294816 | 0.613535 | 0.458858 | 0.314609 | 2.776971 | 3.125320 | 8.390625 | 36 | 2017-02-28 | 456 |
| 3 | 316477 | Ph7IvMxuu+1hJp8qYOAy5llX7D97espKsmhEgicBKls= | 1 | 6.3 | 2 | 7 | 2015-10-04 | 0 | 19 | 1 | 30.000000 | 1 | 123.210526 | 123.210526 | 1.0 | 1 | 2015-10-04 | 2017-02-24 | 19 | 2017-03-24 | 0.052632 | 1 | 0.0 | 0.0 | 0 | 4.107018 | 28.789474 | 10 | 1.465636 | 0.636444 | 0.528273 | 0.531189 | 2.770634 | 3.016627 | 8.390625 | 28 | 2017-01-04 | 537 |
| 4 | 293127 | cdrXUooJ9G1gXiLFd5NWqQ5HpgmNzl0aeaojPBJ203k= | 1 | 6.3 | 2 | 7 | 2016-01-31 | 0 | 9 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.0 | 1 | 2016-01-31 | 2017-02-28 | 9 | 2017-03-31 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.222222 | 5 | 2.385141 | 1.377237 | 1.175102 | 1.134550 | 1.969944 | 3.076042 | 8.007812 | 28 | 2017-02-26 | 425 |
| 5 | 23642 | fa9aoepY5IaSL3fZW92105ar3bmT6kea69Qg+7osIfM= | 5 | 24.0 | 0 | 7 | 2015-04-23 | 0 | 24 | 1 | 30.000000 | 1 | 139.000000 | 139.000000 | 1.0 | 1 | 2015-04-23 | 2017-02-21 | 24 | 2017-03-21 | 0.041667 | 1 | 0.0 | 0.0 | 0 | 4.633333 | 29.125000 | 13 | 0.732401 | 0.173287 | 0.168567 | 0.096270 | 2.597737 | 2.526508 | 8.273438 | 36 | 2016-12-28 | 698 |
| 6 | 306400 | U03kCv151wiDiVUUAzAQp3IlXuyNQRs47zJxC3FgSy0= | 1 | 6.3 | 2 | 9 | 2015-01-17 | 0 | 14 | 2 | 26.714286 | 2 | 127.714286 | 127.714286 | 0.0 | 0 | 2015-06-07 | 2017-01-13 | 14 | 2017-02-15 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 4.257143 | 32.142857 | 5 | 1.670639 | 1.216170 | 1.129197 | 0.905319 | 0.308065 | 2.411968 | 6.597656 | 9 | 2017-02-12 | 760 |
| 7 | 160211 | ELGZ1U3Bcg51pCDH17M5EPQnWkvwnTVktorG+Dks2gE= | 11 | 24.0 | 1 | 9 | 2016-12-07 | 0 | 3 | 1 | 30.000000 | 1 | 149.000000 | 149.000000 | 1.0 | 1 | 2016-12-11 | 2017-02-11 | 3 | 2017-03-10 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 4.966667 | 29.000000 | 0 | 0.173287 | 0.086643 | 0.086643 | 0.086643 | 2.665609 | 2.661156 | 8.242188 | 8 | 2017-02-14 | 93 |
| 8 | 225006 | Nv3He2E4qnnPeC1TJulbW84VQouU1S/3Vxuqkhk5Efo= | 1 | 6.3 | 2 | 7 | 2015-07-17 | 0 | 20 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.0 | 1 | 2015-07-17 | 2017-02-16 | 20 | 2017-03-16 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.400000 | 11 | 1.826880 | 1.268888 | 0.366204 | 0.231049 | 0.998577 | 2.531796 | 7.191406 | 3 | 2016-09-26 | 608 |
| 9 | 195028 | YNfyqKWvZ4I8n8uXxQzLr2mSIAoGT1ZFfUrnSH75juU= | 1 | 6.3 | 2 | 13 | 2016-11-20 | 0 | 4 | 1 | 30.000000 | 1 | 100.000000 | 100.000000 | 1.0 | 1 | 2016-11-20 | 2017-02-20 | 4 | 2017-03-19 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 3.333333 | 29.000000 | 0 | 0.767528 | 0.000000 | 0.000000 | 0.000000 | 1.551320 | 1.476939 | 6.660156 | 3 | 2016-11-25 | 119 |
Last rows
| df_index | msno | city | bd | gender | registered_via | registration_init_time | is_churn | total_payment_channels | change_in_payment_methods | payment_plan_days_mean | change_in_plan | plan_list_price_mean | actual_amount_paid_mean | is_auto_renew_mean | is_autorenew_change_flag | transaction_date_min | transaction_date_max | total_transactions | membership_expire_date_max | is_cancel_mean | is_cancel_change_flag | discount_mean | is_discount_mean | is_discount_max | amt_per_day_mean | membership_duration_mean | more_than_30_sum | num_25 | num_50 | num_75 | num_985 | num_100 | num_unq | total_secs | login_freq | last_login | registration_duration | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1610 | 285559 | 29MCa0yiHto8ijGxrOwh/V5Zmc8trpCnJ2GGUOKV4cA= | 1 | 6.3 | 2 | 7 | 2015-11-04 | 0 | 16 | 1 | 30.0 | 1 | 99.0 | 99.0 | 1.000000 | 1 | 2015-11-04 | 2017-02-04 | 16 | 2017-03-04 | 0.0 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.375000 | 9 | 0.703060 | 0.129965 | 0.143912 | 0.000000 | 2.017723 | 2.238298 | 7.660156 | 16 | 2017-02-20 | 486 |
| 1611 | 259760 | InfWiv47k4qSKgXjv6euBVdz1XKs5lAn2Jq3qgJqGE0= | 5 | 27.0 | 2 | 4 | 2016-09-27 | 0 | 5 | 2 | 30.0 | 1 | 161.4 | 161.4 | 0.600000 | 1 | 2016-10-02 | 2017-02-01 | 5 | 2017-03-01 | 0.0 | 0 | 0.0 | 0.0 | 0 | 5.380000 | 30.600000 | 3 | 1.329422 | 0.655878 | 0.086643 | 0.173287 | 3.928295 | 3.753964 | 9.515625 | 8 | 2017-01-21 | 155 |
| 1612 | 52984 | j6ac4+IFzBBHgOJmbJfRxDSfiw13wqx2lefAHO8D1ig= | 1 | 6.3 | 2 | 7 | 2016-12-17 | 0 | 3 | 1 | 30.0 | 1 | 99.0 | 99.0 | 1.000000 | 1 | 2016-12-17 | 2017-02-16 | 3 | 2017-03-16 | 0.0 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 29.666667 | 1 | 1.343820 | 0.000000 | 0.000000 | 0.274653 | 2.374406 | 2.417573 | 7.968750 | 4 | 2017-01-10 | 89 |
| 1613 | 138204 | 03LXJXZDLNp0+7ydhA1FD8/Z/lLeRdEwAqFCrguo/Pc= | 1 | 6.3 | 2 | 7 | 2015-07-26 | 0 | 20 | 1 | 30.0 | 1 | 99.0 | 99.0 | 1.000000 | 1 | 2015-07-26 | 2017-02-26 | 20 | 2017-03-26 | 0.0 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.450000 | 12 | 1.271037 | 0.385862 | 0.043322 | 0.068663 | 2.580483 | 1.978765 | 8.234375 | 16 | 2016-12-09 | 609 |
| 1614 | 247178 | lnnbCdp3Hilj8xZHHV74Yw3ZN3TNT859OkNz0EnqCZ8= | 12 | 6.3 | 2 | 4 | 2016-01-16 | 0 | 14 | 1 | 30.0 | 1 | 149.0 | 149.0 | 1.000000 | 1 | 2016-01-25 | 2017-02-25 | 14 | 2017-03-24 | 0.0 | 0 | 0.0 | 0.0 | 0 | 4.966667 | 29.357143 | 0 | 0.173287 | 0.000000 | 0.000000 | 0.000000 | 1.527312 | 1.818100 | 6.539062 | 4 | 2016-03-07 | 433 |
| 1615 | 289922 | sBWL8NR/nkabY7xm5s5Ud8zQ/kiG+0mjPh9QT/UyGz8= | 6 | 22.0 | 1 | 7 | 2016-01-21 | 0 | 14 | 1 | 30.0 | 1 | 99.0 | 99.0 | 1.000000 | 1 | 2016-01-21 | 2017-02-21 | 14 | 2017-03-21 | 0.0 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.357143 | 8 | 1.748862 | 0.919026 | 0.423193 | 0.486732 | 3.710342 | 3.578337 | 9.195312 | 28 | 2017-01-15 | 425 |
| 1616 | 70835 | Q5EduhXq7EPKTtuUf4mkgoste1YpSTNetjus1YdqhL0= | 1 | 6.3 | 2 | 7 | 2016-01-14 | 0 | 14 | 1 | 30.0 | 1 | 99.0 | 99.0 | 1.000000 | 1 | 2016-01-14 | 2017-02-14 | 14 | 2017-03-14 | 0.0 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.357143 | 8 | 0.665563 | 0.598114 | 0.365941 | 0.000000 | 1.696342 | 2.125916 | 7.660156 | 11 | 2016-07-25 | 425 |
| 1617 | 37685 | n0ghjp6g10QsKB3hGglxB+DRdeCGhsVbFC05o2iTfYk= | 1 | 6.3 | 2 | 7 | 2016-06-05 | 0 | 8 | 1 | 30.0 | 1 | 99.0 | 99.0 | 1.000000 | 1 | 2016-06-05 | 2017-02-05 | 8 | 2017-03-05 | 0.0 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.250000 | 4 | 1.823706 | 0.538445 | 0.443589 | 0.393009 | 2.163773 | 2.552268 | 7.945312 | 20 | 2017-02-15 | 273 |
| 1618 | 139539 | l9HJ1oSxg3e3sJ6ycx2J2no7LM25vitw6gGDWPlLfgE= | 1 | 6.3 | 2 | 7 | 2015-11-16 | 0 | 16 | 1 | 30.0 | 1 | 99.0 | 99.0 | 1.000000 | 1 | 2015-11-16 | 2017-02-16 | 16 | 2017-03-16 | 0.0 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.375000 | 9 | 0.524012 | 0.092420 | 0.258080 | 0.046210 | 1.634552 | 1.890254 | 7.070312 | 15 | 2017-02-25 | 486 |
| 1619 | 138535 | k9qs4yUVW/ZPLqGoBPGRJ1RKcieoC8/8gOPZzkN6vVg= | 14 | 23.0 | 1 | 9 | 2015-04-23 | 0 | 15 | 2 | 30.0 | 1 | 149.0 | 149.0 | 0.933333 | 1 | 2015-06-12 | 2017-01-31 | 15 | 2017-03-27 | 0.0 | 0 | 0.0 | 0.0 | 0 | 4.966667 | 53.400000 | 13 | 1.064211 | 0.211658 | 0.187084 | 0.150600 | 4.235748 | 4.165998 | 9.734375 | 33 | 2017-01-18 | 704 |